Lessons Learned¶

/opt/conda/lib/python3.9/site-packages/geopandas/_compat.py:111: UserWarning: The Shapely GEOS version (3.10.2-CAPI-1.16.0) is incompatible with the GEOS version PyGEOS was compiled with (3.10.1-CAPI-1.16.0). Conversions between both will be slow.
  warnings.warn(

Basics¶

'346 total applications'

'121 different organizations applied.'

How many applications were submitted through the consolidated application?

Yes    343
No       3
Name: consolidated_application, dtype: int64

How many applications were submitted vs. not submitted?

Submitted        338
Not Submitted      8
Name: application_status, dtype: int64

The following organizations did not submit their one of applications.

['City of Tracy',
 'County of Siskiyou',
 'Metropolitan Transportation Commission',
 'Redding Area Bus Aurthority',
 'San Francisco Municipal Transportation Agency',
 'Tuolumne County Transit Agency',
 'Western Contra Costa Transit Authority']

Total Funds Requested - $624 Million¶

Only includes 'state total' and 'federal total.'

/tmp/ipykernel_7186/3732048006.py:2: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.

	total_state_fed_only
346	$624.0M

How was the funding split?¶

Bulk of the funding comes from state grants.

/tmp/ipykernel_7186/415235289.py:1: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.

What are the most popular funds, looking at amount requested?¶

The most popular grant is LCTOP, "Other" state funds, and Transit Development Act.

/tmp/ipykernel_7186/943889312.py:2: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.

Are projects fully funded?¶

Methodology

Totaled up "local total", "federal total", "other federal funds", and "state funds".
Compared the total above with "total expenses" column.
Categorized the comparison into fully funded, funding exceeds total expense, and not fully funded.

What do organizations want to do with the grant funding?¶

Most applications are for projects related to Operating Assistance.

What are the most popular combinations of programs an organization applies for?¶

There are only 335 rows in this data set. There are 346 rows in the original dataframe.
- This is due to the fact that I had to pivot the data different and filtered out any rows with $0 below across all monetary fields and rows with values populated only in the state total or federal total columns.

Looking at the top ten most popular combination of programs
- Majority of applications only applied for LCTOP, followed by 5311, and 5311 in combination with Transit Development Act.

	all_programs	values	percentage_of_total_applications
0	LCTOP (State)	99	30%
1	5311 (Fed)	72	21%
2	5311 (Fed),Transit Development Act (State)	39	12%
3	5339 (Fed)	29	9%
4	5311(f) (Fed)	15	4%
5	5311 (Fed),Other State Funds	14	4%
6	5339 (Fed),Other State Funds	11	3%
7	5311(f) (Fed),Transit Development Act (State)	9	3%
8	5311 CMAQ (Fed)	6	2%
9	5311 (Fed),SB1. State of Good Repair (State),Transit Development Act (State)	5	1%

Analyzing applications that include LCTOP and at least one other grant:¶

23 total applications.
12 different combinations of applications including LCTOP and 1+ program.
LCTOP and Other State Funds is the most popular combination, followed by 5311 and LCTOP.

	program combinations	count of applications in this combination
0	LCTOP (State),Other State Funds	5
1	5311 (Fed),LCTOP (State)	3
2	5311 (Fed),LCTOP (State),SB1. State of Good Repair (State),Other State Funds	2
3	5311 (Fed),LCTOP (State),SB1. State of Good Repair (State),Transit Development Act (State),Other State Funds	2
4	5311 (Fed),LCTOP (State),Transit Development Act (State)	2
5	5311 (Fed),LCTOP (State),Transit Development Act (State),Other State Funds,Other Federal Funds	2
6	LCTOP (State),SB1. State of Good Repair (State)	2
7	5311 (Fed),LCTOP (State),Other Federal Funds	1
8	5311 CMAQ (Fed),LCTOP (State),Other State Funds	1
9	LCTOP (State),Other Federal Funds	1
10	LCTOP (State),Other State Funds,Other Federal Funds	1
11	LCTOP (State),Transit Development Act (State),Other Federal Funds	1

How many applications did organizations submitted?¶

Most organizations (38) submitted one application. One organization submitted thirteen applications.

Methodology

Step 1 : Grouped by organization name and count the number of project upin numbers. Each upin number is unique to each application.
- Example: Amador Transit applied 6 separate times.
Step 2 : Group again to see how many organizations applied for 1,2, etc. applications

How much funding did organizations by district request?¶

Hover over for number of applications and funding.
Agencies in District 6 (Fresno) submitted the highest number of separate applications.
Applicants in District 4 (Bay Area) asked for the most funding.

Which organizations applied? How much did they ask for?¶

District 4, Bay Area recorded the most organizations (23) that applied for grants. District 12, Orange County (1) had the least number of applicants.
Top 5 organizations that asked for the most funding:
- Peninsula Corridor Join Powers Board asked for the most funding (182 million), followed by LA Metro (102 million).
- 2/5 organizations are from District 4 and 2/5 are from District 6 Fresno.
Most organizations requested funds within the 50th percentile.

Top 5 organizations by total funding they requested

	organization_name	full_district_name	total (millions)
0	Peninsula Corridor Joint Powers Board	District 4: Bay Area / Oakland	$182.8M
1	Los Angeles County Metropolitan Transportation Authority	District 7: Los Angeles	$102.48M
2	Tulare County Regional Transportation Agency	District 6: Fresno / Bakersfield	$27.67M
3	Kern Regional Transit	District 6: Fresno / Bakersfield	$23.6M
4	San Francisco Municipal Transportation Agency	District 4: Bay Area / Oakland	$20.34M

Number of organizations that applied for funds by district

	count_of_organizations
full_district_name
District 12: Orange County	1
District 11: San Diego	3
District 9: Bishop	4
District 7: Los Angeles	6
District 1: Eureka	7
District 2: Redding	9
District 5: San Luis Obispo / Santa Barbara	10
District 8: San Bernardino / Riverside	12
District 10: Stockton	13
District 3: Marysville / Sacramento	15
District 6: Fresno / Bakersfield	18
District 4: Bay Area / Oakland	23

What mix of funds did organizations apply for?¶

Interpretation Examples

Amador Transit submitted 4 separate applications only for 5339. Submitted 2 separate applications asking for both LCTOP and 5311 funds.
City of Escalon had 1 application, only for 5311 fund.
- They submitted 2 applications applying to a total of 5 programs: 5311 (Fed),LCTOP (State),SB1. State of Good Repair (State),Transit Development Act (State),Other State Funds
Eastern Sierra Transit Authority submitted 13 different applications.
- 4 applications were for 5311 only.
- 1 application for 5311f and Transit Development Act
- 1 for 5311f, Transit Devleopment Act, and Other State Funds
- 4 for 5339 only
- 2 for LCTOP only
- 1 for LCTOP and SB1 State of Good Repair.

		# of programs in a particular application	# of times the org submitted an application in this particular combination
organization_name	all_programs
Alameda-Contra Costa Transit District	LCTOP (State)	1	2
Amador Transit	5311 (Fed),LCTOP (State)	2	2
Amador Transit	5339 (Fed)	1	4
Butte County Association of Governments/ Butte Regional Transit	5311 (Fed),Transit Development Act (State)	2	2
	5311(f) (Fed),Transit Development Act (State)	2	1
Calaveras Transit Agency	5311 (Fed),Transit Development Act (State)	2	2
Calaveras Transit Agency	LCTOP (State)	1	1
City of Arcata	LCTOP (State)	1	1
City of Arvin	5311 (Fed),Transit Development Act (State)	2	2
City of Arvin	5339 (Fed)	1	3
City of Auburn	5311 (Fed),SB1. State of Good Repair (State),Transit Development Act (State)	3	1
City of Banning	LCTOP (State)	1	1
City of Beaumont	LCTOP (State)	1	1
City of California City	5311 (Fed)	1	2
City of Chowchilla	5311 (Fed),Transit Development Act (State)	2	2
City of Clovis	LCTOP (State)	1	1
City of Corcoran - Corcoran Area Transit	5311 (Fed)	1	2
City of Corcoran - Corcoran Area Transit	LCTOP (State)	1	1
City of Davis	LCTOP (State)	1	1
City of Dixon	5311 (Fed)	1	3
	5311 (Fed),LCTOP (State)	2	1
	5311 (Fed),Transit Development Act (State)	2	1
City of Escalon	5311 (Fed)	1	1
City of Escalon	5311 (Fed),LCTOP (State),SB1. State of Good Repair (State),Transit Development Act (State),Other State Funds	5	2
City of Fairfield	LCTOP (State),Other Federal Funds	2	1
City of Fresno	LCTOP (State)	1	2
City of Guadalupe	5311 (Fed)	1	2
	5339 (Fed)	1	4
	LCTOP (State)	1	1
City of Manteca	LCTOP (State)	1	1
City of McFarland	5311 (Fed),Other State Funds	2	2
City of McFarland	LCTOP (State)	1	1
City of Needles	5311 (Fed),SB1. State of Good Repair (State),Transit Development Act (State)	3	2
City of Ojai	5311 (Fed),Other State Funds	2	2
City of Ojai	5311 CMAQ (Fed)	1	1
City of Ridgecrest	5311 (Fed),Transit Development Act (State)	2	2
City of Rio Vista	5311 (Fed)	1	1
City of Rio Vista	5311 (Fed),Transit Development Act (State)	2	2
City of Roseville	5311 CMAQ (Fed),LCTOP (State),Other State Funds	3	1
City of Roseville	LCTOP (State)	1	1
City of San Luis Obispo Transit	LCTOP (State)	1	1
City of Santa Rosa	LCTOP (State)	1	1
City of Shafter	5311 (Fed),Transit Development Act (State)	2	2
City of Shafter	LCTOP (State),SB1. State of Good Repair (State)	2	1
City of Solvang	5311 (Fed),Transit Development Act (State)	2	2
City of Solvang	LCTOP (State)	1	1
City of Taft	5311 (Fed),Transit Development Act (State)	2	2
City of Taft	LCTOP (State),Other State Funds	2	1
City of Tehachapi	5311 (Fed),Transit Development Act (State)	2	2
City of Tracy	LCTOP (State)	1	1
City of Union City	Other State Funds	1	1
City of Visalia	LCTOP (State)	1	1
City of Wasco	5311 (Fed),Transit Development Act (State)	2	2
City of Wasco	LCTOP (State)	1	1
Colusa County Transit Agency	LCTOP (State)	1	1
County Connection	LCTOP (State)	1	2
County of Los Angeles - Department of Public Works	5311 (Fed)	1	2
County of Mariposa	5311 (Fed)	1	2
County of Nevada Public Works, Transit Services Division	5311 (Fed),Transit Development Act (State)	2	1
County of Nevada Public Works, Transit Services Division	LCTOP (State)	1	1
County of Sacramento Department of Transportation	5311 (Fed)	1	2
County of Shasta Department of Public Works	5311 (Fed),Other State Funds	2	2
County of Shasta Department of Public Works	5311(f) (Fed)	1	1
County of Siskiyou	LCTOP (State)	1	3
County of Tulare	LCTOP (State)	1	1
Eastern Contra Costa Transit Authority	LCTOP (State)	1	1
Eastern Sierra Transit Authority	5311 (Fed)	1	4
	5311(f) (Fed),Transit Development Act (State)	2	1
	5311(f) (Fed),Transit Development Act (State),Other State Funds	3	1
	5339 (Fed)	1	4
	LCTOP (State)	1	2
	LCTOP (State),SB1. State of Good Repair (State)	2	1
El Dorado County Transit Authority	5311 (Fed)	1	2
	5311(f) (Fed)	1	1
	LCTOP (State)	1	1
	LCTOP (State),Other State Funds	2	1
Fresno County Rural Transit Agency	5311 (Fed)	1	2
Fresno County Rural Transit Agency	LCTOP (State)	1	1
Glenn County Transportation Commission	5311 (Fed)	1	1
Golden Empire Transit District	LCTOP (State)	1	1
Golden Gate Highway & Transportation District	LCTOP (State),Other State Funds,Other Federal Funds	3	1
Greyhound Lines, Inc.	5311(f) (Fed)	1	1
Humboldt Transit Authority	5311 (Fed)	1	2
	5311 (Fed),Transit Development Act (State)	2	2
	5311(f) (Fed),Transit Development Act (State)	2	2
	5339 (Fed)	1	1
	LCTOP (State)	1	1
Imperial County Transportation Commission	5311 (Fed),Transit Development Act (State),Other State Funds,Other Federal Funds	4	2
Imperial County Transportation Commission	LCTOP (State)	1	1
Kern Regional Transit	5311 (Fed),Transit Development Act (State)	2	2
	5339 (Fed),Other State Funds	2	3
	LCTOP (State)	1	1
Kings County Area Public Transit Agency	5311 (Fed)	1	2
Kings County Area Public Transit Agency	LCTOP (State)	1	3
Lake Transit Authority	5311 (Fed)	1	2
	5311(f) (Fed)	1	2
	5339 (Fed),Other State Funds	2	4
	LCTOP (State)	1	1
Lassen Transit Service Agency	5311 (Fed),Other State Funds	2	2
Lassen Transit Service Agency	5339 (Fed)	1	3
Livermore Amador Valley Transit Authority	5311 (Fed)	1	2
Livermore Amador Valley Transit Authority	LCTOP (State)	1	1
Los Angeles County Metropolitan Transportation Authority	LCTOP (State)	1	2
Madera County	5311 (Fed),Transit Development Act (State)	2	2
Madera County Transportation Commission	LCTOP (State)	1	3
Marin County Transit District	5311 (Fed)	1	2
Marin County Transit District	LCTOP (State)	1	1
Mendocino Transit Authority	5311 (Fed)	1	2
Mendocino Transit Authority	5311(f) (Fed)	1	1
Metropolitan Transportation Commission	LCTOP (State)	1	2
Modoc Transportation Agency	5311 (Fed),Transit Development Act (State)	2	1
Modoc Transportation Agency	5311(f) (Fed),Transit Development Act (State)	2	3
Monterey-Salinas Transit	5311 (Fed)	1	2
	5311(f) (Fed)	1	1
	LCTOP (State)	1	4
Morongo Basin Transit Authority	5311 (Fed)	1	2
	5311 CMAQ (Fed)	1	1
	LCTOP (State)	1	2
Mountain Area Regional Transit Authority	5311 (Fed)	1	2
	5311 CMAQ (Fed)	1	4
	5311(f) (Fed)	1	2
	LCTOP (State)	1	1
Napa Valley Transportation Authority	5311 (Fed),Transit Development Act (State)	2	1
	5311(f) (Fed),Transit Development Act (State)	2	2
	Other State Funds	1	1
North County Transit District	5311 (Fed)	1	2
North County Transit District	LCTOP (State)	1	1
Omnitrans	LCTOP (State)	1	2
Orange County Transportation Authority	LCTOP (State)	1	2
Palo Verde Valley Transit Agency	5311 (Fed),Transit Development Act (State)	2	1
Peninsula Corridor Joint Powers Board	LCTOP (State),Other State Funds	2	1
Plumas County Transportation Commission	5311 (Fed),SB1. State of Good Repair (State),Transit Development Act (State)	3	2
	5311(f) (Fed),SB1. State of Good Repair (State),Other State Funds	3	1
	5311(f) (Fed),SB1. State of Good Repair (State),Transit Development Act (State)	3	1
	5339 (Fed)	1	3
	LCTOP (State)	1	1
Redding Area Bus Aurthority	LCTOP (State)	1	1
Redwood Coast Transit Authority	5311 (Fed)	1	2
	5311(f) (Fed)	1	1
	5339 (Fed)	1	3
	LCTOP (State)	1	1
Riverside County Transportation Commission	LCTOP (State)	1	1
Riverside Transit Agency	5311 (Fed)	1	2
Riverside Transit Agency	LCTOP (State)	1	1
Sacramento Regional Transit District	LCTOP (State)	1	6
San Benito County Local Transportation Authority	5311 (Fed),Transit Development Act (State)	2	2
San Benito County Local Transportation Authority	LCTOP (State)	1	2
San Bernardino County Transportation Authority	LCTOP (State)	1	2
San Diego Metropolitan Transit System	5311(f) (Fed)	1	1
San Diego Metropolitan Transit System	LCTOP (State)	1	1
San Francisco Bay Area Rapid Transit	LCTOP (State)	1	1
San Francisco Bay Area Water Emergency Transportation Authority	LCTOP (State)	1	1
San Francisco Municipal Transportation Agency	LCTOP (State)	1	2
San Joaquin Regional Rail Commission	LCTOP (State)	1	1
San Joaquin Regional Transit District	5311 (Fed)	1	2
San Joaquin Regional Transit District	LCTOP (State)	1	1
San Luis Obispo Regional Transit Authority	5311 (Fed),Transit Development Act (State)	2	2
San Luis Obispo Regional Transit Authority	LCTOP (State),Transit Development Act (State),Other Federal Funds	3	1
San Mateo County Transit District	5311 (Fed)	1	2
San Mateo County Transit District	Other State Funds,Other Federal Funds	2	1
Santa Barbara County Association of Governments	LCTOP (State)	1	1
Santa Barbara Metropolitan Transit District	Other State Funds	1	1
Santa Clara Valley Transportation Authority	5311 (Fed)	1	2
Santa Clara Valley Transportation Authority	Other State Funds	1	1
Santa Cruz County Regional Transportation Commission	LCTOP (State)	1	1
Santa Cruz Metropolitan Transit District	5311 (Fed)	1	2
	5339 (Fed)	1	1
	LCTOP (State)	1	1
Shasta Regional Transportation Agency	LCTOP (State)	1	1
Sierra County Transportation Commission	5311 (Fed)	1	2
Sierra County Transportation Commission	5339 (Fed)	1	2
Solano County Transit	LCTOP (State),Other State Funds	2	1
Sonoma County Transit	5311 (Fed)	1	2
Sonoma-Marin Area Rail Transit District	LCTOP (State)	1	1
Southern California Regional Rail Authority	LCTOP (State)	1	1
Stanislaus Council of Governments	LCTOP (State)	1	1
Stanislaus Regional Transit Authority	5311 (Fed),Transit Development Act (State)	2	2
Sunline Transit Agency	5311 (Fed)	1	2
	5311(f) (Fed)	1	1
	LCTOP (State)	1	1
Tehama County Transit Agency	5311 (Fed),LCTOP (State),Transit Development Act (State)	3	2
Tehama County Transit Agency	LCTOP (State)	1	1
Town of Truckee	5311 (Fed),LCTOP (State),Transit Development Act (State),Other State Funds,Other Federal Funds	5	2
Trinity County Department of Transportation	5311 (Fed)	1	4
	5311(f) (Fed)	1	2
	5339 (Fed)	1	1
Tulare County Regional Transportation Agency	5311 (Fed),Transit Development Act (State),Other Federal Funds	3	2
Tulare County Regional Transportation Agency	5339 (Fed),Other State Funds	2	4
Tuolumne County Transit Agency	5311 (Fed),LCTOP (State),SB1. State of Good Repair (State),Other State Funds	4	2
Tuolumne County Transit Agency	LCTOP (State)	1	1
Ventura County Transportation Commission	5311 (Fed),Other State Funds	2	2
Ventura County Transportation Commission	LCTOP (State)	1	2
Victor Valley Transit Authority	5311 (Fed),LCTOP (State),Other Federal Funds	3	1
Victor Valley Transit Authority	5311 (Fed),Other Federal Funds	2	1
Western Contra Costa Transit Authority	LCTOP (State)	1	1
Yolo County Transportation District	5311 (Fed)	1	2
Yolo County Transportation District	LCTOP (State),Other State Funds	2	1
Yuba-Sutter Transit Authority	5311 (Fed)	1	2
	5311 (Fed),Other State Funds	2	4
	LCTOP (State)	1	1
Yurok Tribe Transit	5311(f) (Fed)	1	1